package com.xgy.backend.mapper;

import com.xgy.backend.dto.BoardKifuDto;
import com.xgy.backend.domain.Level0Board;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author golaxy
* @description 针对表【level0_board】的数据库操作Mapper
* @createDate 2023-09-12 11:51:36
* @Entity com.xgy.backend.domain.Level0Board
*/
public interface Level0BoardMapper extends BaseMapper<Level0Board> {

    //@Select("SELECT * FROM level0_board WHERE bid BETWEEN #{startId} AND #{endId}")
    List<BoardKifuDto> selectByIdRange(@Param("moveNumFrom") Integer moveNumFrom,@Param("moveNumTo") Integer moveNumTo,
                                       @Param("blackWinRateFrom") Float blackWinRateFrom,@Param("blackWinRateTo") Float blackWinRateTo,
                                       @Param("blackScoreRegFrom") Integer blackScoreRegFrom,@Param("blackScoreRegTo") Integer blackScoreRegTo,
                                       @Param("startId") int startId, @Param("endId") int endId

    );
}




